<?php
/**
 * ShopEx licence
 *
 * @copyright  Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn)
 * @license  http://ecos.shopex.cn/ ShopEx License
 */

$db['member_shenhe']=array (
    'columns' =>
    array (
            'shenhe_id' =>
            array (
                'type' => 'number',
                'required' => true,
                'pkey' => true,
                'extra' => 'auto_increment',
                'label' => app::get('b2c')->_('审核id'),
                'width' => 110,
                'comment' => app::get('b2c')->_('审核id'),
                'editable' => false,
                'hidden' => true,
                'in_list' => false,
                'default_in_list' => true,
            ),
           'member_id' =>
                array (
                   'type' => 'number',
                   'label' => app::get('b2c')->_('会员用户名'),
                   'width' => 110,
                   'comment' => app::get('b2c')->_('会员用户名'),
                   'editable' => false,
                   'hidden' => true,
                   // 'in_list' => true,
                   // 'default_in_list' => true,
                ),
            'login_account' =>
            array (
                'type' => 'varchar(255)',
                'required' => false,
                'label' => app::get('b2c')->_('用户名'),
                'width' => 110,
                'editable' => true,
                'comment' => app::get('b2c')->_('用户名'),
                'in_list' => true,
            ),
           'modify_advance' =>
            array (
                'type' => 'money',
                'required' => true,
                'default' => 0,
                'label' => app::get('b2c')->_('出入金额'),
                'width' => 110,
                'comment' => app::get('b2c')->_('出入金额'),
                'editable' => false,
                'hidden' => true,
                'in_list' => true,
            ),
           'modify_advance_type' =>
            array (
                'type' =>
                array (
                  0 => app::get('b2c')->_('信用额度'),
                  1 => app::get('b2c')->_('实际预存'),
                  2 => '-',
                ),
                'default' => '2',
                'required' => true,
                'label' => app::get('b2c')->_('信用额度类型'),
                'width' => 110,
                'editable' => true,
                'comment' => app::get('b2c')->_('信用额度类型'),
                'in_list' => true,
            ),
            'modify_bank_name' =>
            array (
                'type' => 'varchar(255)',
                'required' => false,
                'label' => app::get('b2c')->_('充值账户'),
                'width' => 110,
                'editable' => true,
                'comment' => app::get('b2c')->_('充值账户'),
                'in_list' => true,
            ),
            'modify_memo' =>
            array (
                'type' => 'varchar(255)',
                'label' => app::get('b2c')->_('管理备注'),
                'is_title' => true,
                'width' => 110,
                'comment' => app::get('b2c')->_('管理备注'),
                'editable' => true,
                'in_list' => true,
            ),
            'mtime' =>
            array (
                'type' => 'time',
                'required' => true,
                'default' => 0,
                'label' => app::get('b2c')->_('充值时间'),
                'width' => 75,
                'comment' => app::get('b2c')->_('充值时间'),
                'editable' => false,
                'in_list' => true,
                'orderby'=>true,
            ),
            'shenhe_state' =>
            array (
                'type' =>
                array (
                  0 => app::get('b2c')->_('审核中'),
                  1 => app::get('b2c')->_('审核通过'),
                  2 => app::get('b2c')->_('审核拒绝'),
                ),
                'default' => '0',
                'required' => true,
                'label' => app::get('b2c')->_('审核结果'),
                'width' => 110,
                'editable' => true,
                'comment' => app::get('b2c')->_('审核结果'),
                'in_list' => true,
            ),
            'disabled' =>
              array (
                'type' => 'bool',
                'default' => 'false',
                'required' => true,
                'comment' => app::get('b2c')->_('失效'),
                'editable' => false,
                'label' => app::get('b2c')->_('失效'),
                'in_list' => true,
            ),
            'op_time' =>
            array (
                'type' => 'time',
                'required' => true,
                'default' => 0,
                'label' => app::get('b2c')->_('审核时间'),
                'width' => 75,
                'comment' => app::get('b2c')->_('审核时间'),
                'editable' => false,
                'in_list' => true,
            ),
            'operator' =>
            array (
                'type' => 'varchar(50)',
                'required' => false,
                'label' => app::get('b2c')->_('审核人'),
                'width' => 110,
                'editable' => true,
                'comment' => app::get('b2c')->_('审核人'),
                'in_list' => true,
            ),

     ),
    'comment' => app::get('b2c')->_('预存款历史记录'),
    'index' =>
    array (
        'ind_mtime' =>
        array (
            'columns' =>
            array (
               0 => 'mtime',
            ),
        ),
        'ind_disabled' =>
        array (
            'columns' =>
            array (
               0 => 'disabled',
            ),
        ),
    ),
    'engine' => 'innodb',
    'version' => '$Rev: 40912 $',
    'comment' => app::get('b2c')->_('会员预存款审核记录表'),
);
